Sales By Location 18
1.Open a new
sheet
2. Click on Format and select shading and select
sheet>worksheet and select color #e8edda
3. Drag and
drop State to Details under Marks
4. Drag and drop Sales to color and total volume, and average price in tool tip under marks card. Right click Average Price and select measure> Average
5. Select Map
in the menu bar select Background maps > Normal.
6. Click on Map layers uncheck everything and only keep Country/Region Names, Country/Region Borders , State/ Province borders and Sate/Province Name.
7. Select legend at the right side and right click > select Edit colors > in the popup window select for the palette select Green color . Clock OK.
8. Right click Sum
sales color under marks and select Format > Pane >Numbers(Custom) >
decimal Places 2 , Display Units Millions , Prefix as $.
Similarly
select right click Total Volume and
select Format > Pane >Numbers(Custom) > decimal Places 2 , Display
Units Millions .
Again select
Average right click and select Format > Pane >Numbers(Custom) >
decimal Places 2 ,Prefix as $.
9. Select the Title and rt select Edit Title > Erase the text and type Sales By Location Change the font to Tableau Semi bold > Font size to 10 > Font Color Black >Alignment Center.
10. Increase/ Decrease the size of Map using the + and - control in the Map